Show All

Create an OLAP query file to connect to an OLAP database

You can also use Office database connection (.odc) files to connect to OLAP databases.

1. Create a new data source that uses the name you want for the OLAP query (.oqy) file as the name of the data source.

   How?

   1. Under the Data menu, point to Import External Data, and then click New Database Query.

   2. In the Choose Data Source dialog box, on the OLAP Cubes tab, click New Data Source, and then click OK.

   3. Choose a name for the data source, select an OLAP provider, and click Connect.

   4. Complete the Multi-Dimensional Connection wizard.

2. In the Choose Data Source dialog box, click Options on the OLAP Cubes tab to view the name of the folder where the .oqy file was created. The default location is your user profile folder under Application Data\Microsoft\Queries.

Notes

• When you use the Open command on the Microsoft Excel File menu to open an .oqy file, Excel displays a worksheet with a blank PivotTable report for the OLAP data. You can use this report to display the data you want to see, and then save it in an Excel workbook file.
• You can also use the OLAP Cube Wizard in Microsoft Query to create an .oqy file that connects to a cube file or defines a cube that is created from queried data. For more information, see Microsoft Query Help.